<?php require_once './connection.php'; ?>
<html>

    <?php
    $sql = 'SELECT * FROM staffs';
    $staffs = query($sql);
    ?>
    <table border="1">
        <tr>
            <td colspan="2">staffs</td>
               
        </tr>
        <tr>
            <td width="20">ID</td>
            <td width="100">NAME</td>
            <td width="100">DELETE</td>
        </tr>
        <?php foreach ($staffs as $Staff):?>
        <tr>
            <td width="20"><?php echo $Staff['id'] ?></td>
            <td width="100"><?php echo $Staff['name'] ?></td>
            <td><input type="submit" name="delete" value="delete"></td>
        </tr>
    <?php    endforeach;?>
      </table>
</html>

